<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>Class: DB_Table</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta http-equiv="Content-Script-Type" content="text/javascript" />
  <link rel="stylesheet" href=".././rdoc-style.css" type="text/css" media="screen" />
  <script type="text/javascript">
  // <![CDATA[

  function popupCode( url ) {
    window.open(url, "Code", "resizable=yes,scrollbars=yes,toolbar=no,status=no,height=150,width=400")
  }

  function toggleCode( id ) {
    if ( document.getElementById )
      elem = document.getElementById( id );
    else if ( document.all )
      elem = eval( "document.all." + id );
    else
      return false;

    elemStyle = elem.style;
    
    if ( elemStyle.display != "block" ) {
      elemStyle.display = "block"
    } else {
      elemStyle.display = "none"
    }

    return true;
  }
  
  // Make codeblocks hidden by default
  document.writeln( "<style type=\"text/css\">div.method-source-code { display: none }</style>" )
  
  // ]]>
  </script>

</head>
<body>



    <div id="classHeader">
        <table class="header-table">
        <tr class="top-aligned-row">
          <td><strong>Class</strong></td>
          <td class="class-name-in-header">DB_Table</td>
        </tr>
        <tr class="top-aligned-row">
            <td><strong>In:</strong></td>
            <td>
                <a href="../files/lib/DB_Table_rb.html">
                lib/DB_Table.rb
                </a>
        <br />
            </td>
        </tr>

        <tr class="top-aligned-row">
            <td><strong>Parent:</strong></td>
            <td>
                Object
            </td>
        </tr>
        </table>
    </div>
  <!-- banner header -->

  <div id="bodyContent">



  <div id="contextContent">

    <div id="description">
      <p>
The <a href="DB_Table.html">DB_Table</a> class provides the data structure
and methods require to retrieve the table name, column names, and data
types.
</p>
<pre>
 Public Attributes
 * :tableName - table name
 * :colNames - Array of column names
 * :colDTypes - Array of data types
</pre>

    </div>


   </div>

    <div id="method-list">
      <h3 class="section-bar">Methods</h3>

      <div class="name-list">
      <a href="#M000005">find_cols_types</a>&nbsp;&nbsp;
      <a href="#M000004">find_table_name</a>&nbsp;&nbsp;
      <a href="#M000001">new</a>&nbsp;&nbsp;
      <a href="#M000003">no_comments</a>&nbsp;&nbsp;
      <a href="#M000002">no_inline_comments</a>&nbsp;&nbsp;
      </div>
    </div>

  </div>


    <!-- if includes -->

    <div id="section">





    <div id="attribute-list">
      <h3 class="section-bar">Attributes</h3>

      <div class="name-list">
        <table>
        <tr class="top-aligned-row context-row">
          <td class="context-item-name">colDTypes</td>
          <td class="context-item-value">&nbsp;[R]&nbsp;</td>
          <td class="context-item-desc"></td>
        </tr>
        <tr class="top-aligned-row context-row">
          <td class="context-item-name">colNames</td>
          <td class="context-item-value">&nbsp;[R]&nbsp;</td>
          <td class="context-item-desc"></td>
        </tr>
        <tr class="top-aligned-row context-row">
          <td class="context-item-name">tableName</td>
          <td class="context-item-value">&nbsp;[R]&nbsp;</td>
          <td class="context-item-desc"></td>
        </tr>
        </table>
      </div>
    </div>
      


    <!-- if method_list -->
    <div id="methods">
      <h3 class="section-bar">Public Class methods</h3>

      <div id="method-M000001" class="method-detail">
        <a name="M000001"></a>

        <div class="method-heading">
          <a href="DB_Table.src/M000001.html" target="Code" class="method-signature"
            onclick="popupCode('DB_Table.src/M000001.html');return false;">
          <span class="method-name">new</span><span class="method-args">( aFile )</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
The initialize method instantiates necessary variables and processes the
table file into the data structure. Utilizing the <a
href="DB_Table.html#M000003">no_comments</a>, <a
href="DB_Table.html#M000004">find_table_name</a> and the <a
href="DB_Table.html#M000005">find_cols_types</a> methods.
</p>
        </div>
      </div>

      <h3 class="section-bar">Public Instance methods</h3>

      <div id="method-M000005" class="method-detail">
        <a name="M000005"></a>

        <div class="method-heading">
          <a href="DB_Table.src/M000005.html" target="Code" class="method-signature"
            onclick="popupCode('DB_Table.src/M000005.html');return false;">
          <span class="method-name">find_cols_types</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
retrieves the column names and data types
</p>
        </div>
      </div>

      <div id="method-M000004" class="method-detail">
        <a name="M000004"></a>

        <div class="method-heading">
          <a href="DB_Table.src/M000004.html" target="Code" class="method-signature"
            onclick="popupCode('DB_Table.src/M000004.html');return false;">
          <span class="method-name">find_table_name</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
retrieves the table name from a scrubbed SQL table create statement
</p>
        </div>
      </div>

      <div id="method-M000003" class="method-detail">
        <a name="M000003"></a>

        <div class="method-heading">
          <a href="DB_Table.src/M000003.html" target="Code" class="method-signature"
            onclick="popupCode('DB_Table.src/M000003.html');return false;">
          <span class="method-name">no_comments</span><span class="method-args">()</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
strips SQL comments lines and comment blocks from table file
</p>
        </div>
      </div>

      <div id="method-M000002" class="method-detail">
        <a name="M000002"></a>

        <div class="method-heading">
          <a href="DB_Table.src/M000002.html" target="Code" class="method-signature"
            onclick="popupCode('DB_Table.src/M000002.html');return false;">
          <span class="method-name">no_inline_comments</span><span class="method-args">( s )</span>
          </a>
        </div>
      
        <div class="method-description">
          <p>
strips inline SQL comments
</p>
        </div>
      </div>


    </div>


  </div>


<div id="validator-badges">
  <p><small><a href="http://validator.w3.org/check/referer">[Validate]</a></small></p>
</div>

</body>
</html>